using INTEX.DataBase;
using ReflectionStudio.Core.Events;
using System;
using System.Data;
using System.Windows;
using System.Windows.Data;
using System.Collections;
using System.Collections.Generic;
namespace WPFExcelReport
{
    public partial class VWTSCHUSS : ViewModelBase
    {
        public DataSet LOADBYBS(Dictionary<string, object> pm)
        {

            dwData = TBMain.NewRow();
            dwData["WTSMANDANT"] = app.Mandant;
            dwData["WTSSFLGNR"] = pm["FLGNR"].ToString();
            SResult = QWTS01(dwData);
            return SResult;
        }
        public DataSet CREATEBYBS(Dictionary<string, object> pm)
        {
            dwData = TBMain.NewRow();
            SetUpNewRow(ref dwData);
            dwData["WTSMANDANT"] = app.Mandant;
            dwData["WTSSFLGNR"] =  pm["FLGNR"].ToString();           
            TBMain.Rows.InsertAt(dwData, 0);
            InsertWTSCHUSS(dwData);
            return SResult;
        }

    }
    public partial class VWTSCHUSS
    {
        public string WTSSFLGNR { get { if (dwMaster == null) return ""; return dwMaster["WTSSFLGNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSSFLGNR"] = value; OnPropertyChanged("WTSSFLGNR", value); } } //lENGth 15
        public string WTSSTAKZ { get { if (dwMaster == null) return ""; return dwMaster["WTSSTAKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSSTAKZ"] = value; OnPropertyChanged("WTSSTAKZ", value); } } //lENGth 1

        #region======ColumnSchema==========
        /*
                 public string WTSMANDANT { get { if (dwMaster == null) return ""; return dwMaster["WTSMANDANT"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSMANDANT"] = value; OnPropertyChanged("WTSMANDANT", value); } } //lENGth 2
                 public string WTSBEZ { get { if (dwMaster == null) return ""; return dwMaster["WTSBEZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSBEZ"] = value; OnPropertyChanged("WTSBEZ", value); } } //lENGth 20
                 public string WTSCADKEY1 { get { if (dwMaster == null) return ""; return dwMaster["WTSCADKEY1"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSCADKEY1"] = value; OnPropertyChanged("WTSCADKEY1", value); } } //lENGth 13
                 public string WTSCADKEY2 { get { if (dwMaster == null) return ""; return dwMaster["WTSCADKEY2"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSCADKEY2"] = value; OnPropertyChanged("WTSCADKEY2", value); } } //lENGth 6
                 public string WTSMUSTER { get { if (dwMaster == null) return ""; return dwMaster["WTSMUSTER"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSMUSTER"] = value; OnPropertyChanged("WTSMUSTER", value); } } //lENGth 1
                 public double WTSSRAPP { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WTSSRAPP"].ToString()); } set { if (dwMaster == null) return; dwMaster["WTSSRAPP"] = value; OnPropertyChanged("WTSSRAPP", value); } } //lENGth 0
                 public double WTSGRAPP { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WTSGRAPP"].ToString()); } set { if (dwMaster == null) return; dwMaster["WTSGRAPP"] = value; OnPropertyChanged("WTSGRAPP", value); } } //lENGth 0
                 public string WTSJAC { get { if (dwMaster == null) return ""; return dwMaster["WTSJAC"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSJAC"] = value; OnPropertyChanged("WTSJAC", value); } } //lENGth 1
                 public string WTSPATRONE { get { if (dwMaster == null) return ""; return dwMaster["WTSPATRONE"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSPATRONE"] = value; OnPropertyChanged("WTSPATRONE", value); } } //lENGth 15
                 public string WTSREGU { get { if (dwMaster == null) return ""; return dwMaster["WTSREGU"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSREGU"] = value; OnPropertyChanged("WTSREGU", value); } } //lENGth 10
                 public double WTSANZFARB { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WTSANZFARB"].ToString()); } set { if (dwMaster == null) return; dwMaster["WTSANZFARB"] = value; OnPropertyChanged("WTSANZFARB", value); } } //lENGth 0
                 public string WTSANZMFS { get { if (dwMaster == null) return ""; return dwMaster["WTSANZMFS"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSANZMFS"] = value; OnPropertyChanged("WTSANZMFS", value); } } //lENGth 1
                 public double WTSGRDSCHT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WTSGRDSCHT"].ToString()); } set { if (dwMaster == null) return; dwMaster["WTSGRDSCHT"] = value; OnPropertyChanged("WTSGRDSCHT", value); } } //lENGth 0
                 public string WTSFOLGE { get { if (dwMaster == null) return ""; return dwMaster["WTSFOLGE"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSFOLGE"] = value; OnPropertyChanged("WTSFOLGE", value); } } //lENGth 312
                 public string WTSSCHUSS01 { get { if (dwMaster == null) return ""; return dwMaster["WTSSCHUSS01"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSSCHUSS01"] = value; OnPropertyChanged("WTSSCHUSS01", value); } } //lENGth 400
                 public string WTSSCHUSS02 { get { if (dwMaster == null) return ""; return dwMaster["WTSSCHUSS02"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSSCHUSS02"] = value; OnPropertyChanged("WTSSCHUSS02", value); } } //lENGth 400
                 public double WTSFAKTOR { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WTSFAKTOR"].ToString()); } set { if (dwMaster == null) return; dwMaster["WTSFAKTOR"] = value; OnPropertyChanged("WTSFAKTOR", value); } } //lENGth 0
                 public string WTSFILLER { get { if (dwMaster == null) return ""; return dwMaster["WTSFILLER"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSFILLER"] = value; OnPropertyChanged("WTSFILLER", value); } } //lENGth 91
                 public double WTSAENDZL { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WTSAENDZL"].ToString()); } set { if (dwMaster == null) return; dwMaster["WTSAENDZL"] = value; OnPropertyChanged("WTSAENDZL", value); } } //lENGth 0
                 public string WTSAENDBEN { get { if (dwMaster == null) return ""; return dwMaster["WTSAENDBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSAENDBEN"] = value; OnPropertyChanged("WTSAENDBEN", value); } } //lENGth 8
                 public double WTSAENDDAT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WTSAENDDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["WTSAENDDAT"] = value; OnPropertyChanged("WTSAENDDAT", value); } } //lENGth 0
                 public string WTSNEUBEN { get { if (dwMaster == null) return ""; return dwMaster["WTSNEUBEN"].ToString(); } set { if (dwMaster == null) return; dwMaster["WTSNEUBEN"] = value; OnPropertyChanged("WTSNEUBEN", value); } } //lENGth 8
                 public double WTSNEUDAT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["WTSNEUDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["WTSNEUDAT"] = value; OnPropertyChanged("WTSNEUDAT", value); } } //lENGth 0
        */
        #endregion
    }
}
